package zhongbo.java.air.monitor.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import zhongbo.java.air.monitor.model.AirAlertLog;
import zhongbo.java.air.monitor.model.FlightActivityDaily;

import java.util.Date;
import java.util.List;

@Mapper
public interface AirAlertLogMapper extends BaseMapper<AirAlertLog> {

    /**
     * 查询指定行数据
     *
     * @param offset 偏移量
     * @param pageSize         大小
     * @return 对象列表
     */
    @Select("SELECT * FROM air_alert_log ORDER BY id LIMIT #{pageSize} OFFSET #{offset}")
    List<AirAlertLog> queryAllByLimit(@Param("offset") int offset, @Param("pageSize") int pageSize);
}
